package com.mdinfo.system.mapper;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.mdinfo.system.bean.SysMember;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * Created by Administrator on 2017/11/22.
 */
public interface SysMemberMapper extends BaseMapper<SysMember>{

    /**
     * 根据人员id查询
     */
    SysMember getByEmpId(Integer empId);

    /**
     * 根据用户名查询
     */
    SysMember getByUsername(String username);

    /**
     * 列表条件分页查询
     */
    List<SysMember> listQuery(@Param("start")Integer start,
                              @Param("num")Integer num,
                              @Param("deptId")Integer deptId,
                              @Param("key")String key,
                              @Param("deptList")List<Integer> deptList);

    /**
     * 列表条件查询总数
     */
    int countListQuery(@Param("deptId")Integer deptId,
                       @Param("key")String key,
                       @Param("deptList")List<Integer> deptList);

}
